
---------- DBO.ACCRUALALLOCATIONS.TABLE.SQL

---------- DBO.ACCRUALDETAILS.TABLE.SQL

---------- DBO.ACCRUALGROUPINGS.TABLE.SQL

---------- DBO.ACCRUALHEADERS.TABLE.SQL

---------- DBO.ALLOWANCEDETAILS.TABLE.SQL

---------- DBO.ALLOWANCEDETAILS_SL.TABLE.SQL

---------- DBO.ALLOWANCEHEADERS.TABLE.SQL

---------- DBO.ALLOWANCEHEADERS_SL.TABLE.SQL

---------- DBO.ALLOWANCEIMPORT.TABLE.SQL

---------- DBO.ALLOWANCEMILLALLOC.TABLE.SQL

---------- DBO.ALLOWANCEMILLALLOC_SL.TABLE.SQL

---------- DBO.ALLOWANCES.TABLE.SQL

---------- DBO.ALLOWANCETYPES.TABLE.SQL

---------- DBO.BMDBATCH.TABLE.SQL
/****** Object:  Table [dbo].[BMDBatch]    Script Date: 11/22/2014 08:02:56 ******/
CREATE TABLE [dbo].[BMDBatch](
 CONSTRAINT [PK_BMDBatch] PRIMARY KEY CLUSTERED 

---------- DBO.BMDPRODUCT.TABLE.SQL
/****** Object:  Table [dbo].[BMDProduct]    Script Date: 11/22/2014 08:02:56 ******/
CREATE TABLE [dbo].[BMDProduct](
	[BMDProductDesc] [varchar](50) NOT NULL,
 CONSTRAINT [BMDProduct_PK] PRIMARY KEY CLUSTERED 

---------- DBO.BMDSALES.TABLE.SQL
/****** Object:  Table [dbo].[BMDSales]    Script Date: 11/22/2014 08:02:56 ******/
CREATE TABLE [dbo].[BMDSales](
	[BMDSalesID] [int] IDENTITY(1,1) NOT NULL,
	[BMDShipToID] [int] NOT NULL,
 CONSTRAINT [BMDSales_PK] PRIMARY KEY CLUSTERED 
	[BMDSalesID] ASC
ALTER TABLE [dbo].[BMDSales]  WITH CHECK ADD  CONSTRAINT [FK_BMDSales_BMDBatch] FOREIGN KEY([BatchID])
REFERENCES [dbo].[BMDBatch] ([BatchID])
ALTER TABLE [dbo].[BMDSales] CHECK CONSTRAINT [FK_BMDSales_BMDBatch]
ALTER TABLE [dbo].[BMDSales] ADD  CONSTRAINT [DF_BMDSales_ShipToName]  DEFAULT ('') FOR [ShipToName]
ALTER TABLE [dbo].[BMDSales] ADD  CONSTRAINT [DF_BMDSales_ShipToCity]  DEFAULT ('') FOR [ShipToCity]
ALTER TABLE [dbo].[BMDSales] ADD  CONSTRAINT [DF_BMDSales_ShipToState]  DEFAULT ('') FOR [ShipToState]
ALTER TABLE [dbo].[BMDSales] ADD  CONSTRAINT [DF_BMDSales_Imported]  DEFAULT (0) FOR [Imported]
ALTER TABLE [dbo].[BMDSales] ADD  CONSTRAINT [DF_BMDSales_Deleted]  DEFAULT (0) FOR [Deleted]

---------- DBO.BMDSALES_COPY.TABLE.SQL
/****** Object:  Table [dbo].[BMDSales_copy]    Script Date: 11/22/2014 08:02:56 ******/
CREATE TABLE [dbo].[BMDSales_copy](
	[BMDSalesID] [int] NOT NULL,
	[BMDShipToID] [int] NOT NULL,

---------- DBO.BMDSHIPTO.TABLE.SQL
/****** Object:  Table [dbo].[BMDShipTo]    Script Date: 11/22/2014 08:02:56 ******/
CREATE TABLE [dbo].[BMDShipTo](
	[BMDShipToID] [int] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [BMDShipTo_PK] PRIMARY KEY CLUSTERED 
	[BMDShipToID] ASC
ALTER TABLE [dbo].[BMDShipTo] ADD  CONSTRAINT [DF_BMDShipTo_Deleted]  DEFAULT (0) FOR [Deleted]

---------- DBO.BRIOBRG2.TABLE.SQL

---------- DBO.BRIOCAT2.TABLE.SQL

---------- DBO.BRIODMQ2.TABLE.SQL

---------- DBO.BRIOGRP2.TABLE.SQL

---------- DBO.BRIOOBJ2.TABLE.SQL

---------- DBO.BRIOOCE2.TABLE.SQL

---------- DBO.BRIOSVR2.TABLE.SQL

---------- DBO.BRIOUNIQ.TABLE.SQL

---------- DBO.BRIOUSR2.TABLE.SQL

---------- DBO.BUILDERACTUAL.TABLE.SQL

---------- DBO.BUILDERAREA.TABLE.SQL

---------- DBO.BUILDERCOEFFICIENT.TABLE.SQL

---------- DBO.BUILDERJOISTREWARD.TABLE.SQL

---------- DBO.BUILDERJOISTREWARDMILLALLOC.TABLE.SQL

---------- DBO.BUILDERMILLALLOCADJUST.TABLE.SQL

---------- DBO.BUILDERMILLALLOCPAYMENT.TABLE.SQL

---------- DBO.BUILDERPAYOUTTYPE.TABLE.SQL

---------- DBO.BUILDERREBATEBASEAMT.TABLE.SQL

---------- DBO.BUILDERREBATEBASETYPE.TABLE.SQL

---------- DBO.BUILDERREGION.TABLE.SQL

---------- DBO.BUILDERREGIONACCRUAL.TABLE.SQL

---------- DBO.BUILDERREGIONPAYMENT.TABLE.SQL

---------- DBO.BUILDERREGIONPAYMENTADJUST.TABLE.SQL

---------- DBO.BUILDERRETAILERREGION.TABLE.SQL

---------- DBO.BUILDERRETIRE.TABLE.SQL

---------- DBO.BUILDRITEADDITIONALCHARGES.TABLE.SQL

---------- DBO.BUILDRITEINVOICEHEADERS.TABLE.SQL

---------- DBO.BUILDRITEINVOICELINES.TABLE.SQL

---------- DBO.BUILDRITEPAYMENTS.TABLE.SQL

---------- DBO.BUILDRITEPLANS.TABLE.SQL

---------- DBO.CHECKREQUESTS.TABLE.SQL

---------- DBO.CHECKREQUESTSDETAIL.TABLE.SQL

---------- DBO.CHECKREQUESTSJOURNALENTRYDETAIL.TABLE.SQL

---------- DBO.CHECKREQUESTSVENDORS.TABLE.SQL

---------- DBO.CUSTOMERADDRESSES.TABLE.SQL

---------- DBO.DESTINATION - _BUILDERACCRUALIMPORT.TABLE.SQL

---------- DBO.DESTINATION - _RETAILERACCRUALIMPORT.TABLE.SQL

---------- DBO.DISTRIBUTORCOEFFICIENT.TABLE.SQL

---------- DBO.DISTRIBUTORPAYMENT.TABLE.SQL

---------- DBO.DISTRIBUTORREGION.TABLE.SQL

---------- DBO.DISTRIBUTORRETAILERREGION.TABLE.SQL

---------- DBO.DISTRIBUTORSALES.TABLE.SQL

---------- DBO.DISTRORETAILVOLUME.TABLE.SQL

---------- DBO.DIXIEBATCH.TABLE.SQL

---------- DBO.DIXIEPRODUCT.TABLE.SQL

---------- DBO.DIXIESALES.TABLE.SQL

---------- DBO.DIXIESHIPTO.TABLE.SQL

---------- DBO.FIELDTECHNICALMANAGERS.TABLE.SQL

---------- DBO.GLACCOUNT.TABLE.SQL

---------- DBO.JOISTREWARDACCOUNT.TABLE.SQL

---------- DBO.MARKETREGIONS.TABLE.SQL

---------- DBO.MARKETS.TABLE.SQL

---------- DBO.MILL.TABLE.SQL

---------- DBO.MILLDISTRIBUTOR.TABLE.SQL

---------- DBO.PRODUCT.TABLE.SQL

---------- DBO.REBATEPAYMENTTRANS.TABLE.SQL

---------- DBO.REBATEPROGRAMNOTES.TABLE.SQL

---------- DBO.REBATEPROGRAMS.TABLE.SQL

---------- DBO.REBATETIEREDAMT.TABLE.SQL

---------- DBO.REDUCTIONACCRUALS.TABLE.SQL

---------- DBO.REDUCTIONALLOWANCES.TABLE.SQL

---------- DBO.REDUCTIONBATCHES.TABLE.SQL

---------- DBO.REDUCTIONHEADERS.TABLE.SQL

---------- DBO.REDUCTIONTYPES.TABLE.SQL

---------- DBO.REGIONMARKETS.TABLE.SQL

---------- DBO.RETAILERCOMPENDIUM.TABLE.SQL

---------- DBO.RETAILERPAYOUTTYPE.TABLE.SQL

---------- DBO.RETAILERREBATEPSEUDOPOST.TABLE.SQL

---------- DBO.RETAILERREBATEVISUALOPTION.TABLE.SQL

---------- DBO.RETAILERREBATEVISUALOPTIONTYPE.TABLE.SQL

---------- DBO.RETAILERREGION.TABLE.SQL

---------- DBO.RETAILERREGIONACCRUAL.TABLE.SQL

---------- DBO.RETAILERREGIONCOEFFICIENT.TABLE.SQL

---------- DBO.RETAILERREGIONOTHERREBATEINFO.TABLE.SQL

---------- DBO.RETAILERREGIONPAYMENT.TABLE.SQL

---------- DBO.RETAILERREGIONPAYMENTADJUST.TABLE.SQL

---------- DBO.RETAILERREGIONPAYMENTDETAIL.TABLE.SQL

---------- DBO.RETAILERREGIONREBATEINFO.TABLE.SQL

---------- DBO.RETAILERREGIONSALES.TABLE.SQL
	[BMDSalesID] [int] NULL,

---------- DBO.RETAILERRETIRE.TABLE.SQL

---------- DBO.RETAILERSALESBATCHES.TABLE.SQL

---------- DBO.RETAILMILLALLOC.TABLE.SQL

---------- DBO.RETAILMILLALLOCADJUST.TABLE.SQL

---------- DBO.RETAILMILLALLOCBYPERCENT.TABLE.SQL

---------- DBO.RETAILMILLALLOCBYPRODUCT.TABLE.SQL

---------- DBO.RETAILMILLALLOCBYRETAILERREGION.TABLE.SQL

---------- DBO.RETAILMILLALLOCBYSTATE.TABLE.SQL

---------- DBO.RETAILMILLALLOCPAYMENT.TABLE.SQL

---------- DBO.RETAILREBATETYPE.TABLE.SQL

---------- DBO.STATELIST.TABLE.SQL

---------- DBO.SYSTEMPERMISSIONS.TABLE.SQL

---------- DBO.USERPERMISSIONS.TABLE.SQL

---------- DBO.USERS.TABLE.SQL

---------- DBO._BUILDERACCRUALIMPORT.TABLE.SQL

---------- DBO._CANWELIMPORT.TABLE.SQL

---------- DBO._RETAILERACCRUALIMPORT.TABLE.SQL

---------- SATRACK.ALLOWALLOC_V48TLE.TABLE.SQL

---------- SATRACK.ALLOWALLOC_V5EMDB.TABLE.SQL

---------- SATRACK.ALLOWDTLS_V48TLE.TABLE.SQL

---------- SATRACK.ALLOWDTLS_V5EMDB.TABLE.SQL

---------- SATRACK.ALLOWPYMTS_V48TLE.TABLE.SQL

---------- SATRACK.ALLOWPYMTS_V5EMDB.TABLE.SQL
